package com.hzz.dao.analysis;

import com.hzz.framework.dao.IBaseDao;
import com.hzz.framework.entity.IEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * <p>河长统计分析 数据库处理接口类。
 */
@Mapper
public interface IAnalysisRiverSupervisorDao {

    List<Map> analysisRiverSupervisorAreaLevel(IEntity entity) throws Exception;

    List<Map> analysisRiverSupervisorAreaName(IEntity entity) throws Exception;

    List<Map> analysisRiverSupervisorChildAreaName(IEntity entity) throws Exception;

    @Select("SELECT IFNULL(count(0),0) as count FROM user t1 WHERE t1.del_flag = 0 AND t1.type = 1 AND t1.state = 0")
    int analysisRiverSupervisor(IEntity entity) throws Exception;
}
